Labels:text | screenshot | font | number | document | black and white OCR: Small 1) set PCTFREE low, either 5 percent or 10 percent Dimension 2) set PCTUSED high, either 80 percent or 90 percent Tables 3) set CACHE 4) set NOPARALLEL 5) set INITIAL extent to hold entire table 6) set NEXT extent to 1/4 to 1/2 of INITIAL 7) set PCTINCREASE to 0 Large 8) set PCTFREE low, either 5 percent or 10 percent Dimension 9) set PCTUSED high, either 80 percent or 90 percent Tables 10) set NOCACHE 11) sel NOPARALLEL 12) sel INITIAL extent to hold 1/4 to 1/2 of table 13) set NEXT extent to hold 1/4 to 1/2 of table 14) set PCTINCREASE to 0 Fact Tables 15) set PCTFREE low, either 5 percent or 10 percent 16) set PCTUSED high, either 80 percent or 90 percent 17) set NOCACHE 18) set PARALLEL to 2 * CPU count 19) stripe table manually or through OS 20) cluster the table on leading portion of PK 21) set INITIAL extent to 1/4 to 1/2 of tablespace 22) set NEXT extent to 1/4 to 1/2 of tablespace 23) set PCTINCREASE to 0 Figure 4 : Database object physical storage and space usage.
